package com.qianyu.project.mapper.provider.zy;

import com.baomidou.mybatisplus.core.metadata.IPage;
import com.qianyu.project.entity.ProjectInfo;
import org.apache.ibatis.jdbc.SQL;
import org.springframework.util.ObjectUtils;

import java.util.Map;

public class ZYProjectInfoProvider {
    public String getZYList(){
        return new SQL(){
            {
//                select * from project_info pi,project_type pt where pt.type_id=pi.project_type
                SELECT("*");
                FROM("project_info pi,project_type pt");
                WHERE("pt.type_id=pi.project_type");

            }
        }.toString();
    }




}
